////////////////////////////////////////////////////////////////////////////////
// Copyright 2006 CORE Solutions Limited
// All rights reserved.
// PROPRIETARY AND CONFIDENTIAL INFORMATION.
// Use is subject to license terms.
//
// FUNCTION ID      :   StatusConstantsQuery.java
// AUTHOR           :   ric.yik
// DATE CREATE      :   2006/6/22
// DESCRIPTION      :   
//                  :   
//                  :   
//                  :   
//
// MODIFICATION HISTORY:
// DATE         AUTHOR          VERSION NO.         COMMENT
// -----------  --------------  ------------------  -------------------
// 2006/6/22      ric.yik         1.0                 source is created.
//
//
//
////////////////////////////////////////////////////////////////////////////////

package com.erp.app.common.query;

public class StatusConstantsQuery extends BeanQuery {

    private String type;

    private String order;

    public StatusConstantsQuery() {
        super("SELECT STATUS_CODE, STATUS_DESC FROM T_STATUS_CONSTANTS WHERE TYPE = `type:string` ORDER BY `order`");
        this.setModel(this);
        this.setOrder("ORDER_SEQ, STATUS_DESC, STATUS_CODE");
    }

    public String getOrder() {
        return order;
    }

    public StatusConstantsQuery setOrder(String order) {
        this.order = order;
        return this;
    }

    public String getType() {
        return type;
    }

    public StatusConstantsQuery setType(String type) {
        this.type = type;
        return this;
    }

}
